Hi,

Can somebody point me in the right direction with this code. I am simply
trying to change the name of a worksheet in Excel but I cant get it to
work....

systemClient = DDEClient.Make( "Excel", "System")
mystring = ("[WORKBOOK.NAME(""SHEET1"",""BENZENE"")]")
systemClient.Execute(mystring)
systemClient.Close

Thanks in advance,

Nigel Tait